<?php

use yii\db\Migration;

class m240417_014729_diandi_place_room extends Migration
{
    public function up()
    {
        /* 取消外键约束 */
        $this->execute('SET foreign_key_checks = 0');
        
        /* 创建表 */
        $this->createTable('{{%diandi_place_room}}', [
            'id' => "int(11) NOT NULL AUTO_INCREMENT",
            'bloc_id' => "int(11) NULL DEFAULT '0' COMMENT '公司ID'",
            'store_id' => "int(11) NULL COMMENT '商户ID'",
            'hotel_id' => "int(11) NULL DEFAULT '0' COMMENT '酒店ID'",
            'type_id' => "int(11) NULL COMMENT '房源类型，酒店，民宿，公寓等'",
            'title' => "varchar(255) NULL DEFAULT '' COMMENT '房间名称'",
            'tier_id' => "int(11) NULL COMMENT '楼层'",
            'unit_id' => "int(11) NULL COMMENT '单元'",
            'thumb' => "varchar(255) NULL DEFAULT '' COMMENT '房间主图'",
            'oprice' => "decimal(11,2) NULL DEFAULT '0.00' COMMENT '原价'",
            'cprice' => "decimal(11,2) NULL DEFAULT '0.00' COMMENT '现价'",
            'mprice' => "decimal(11,2) NULL DEFAULT '0.00' COMMENT '会员价'",
            'thumbs' => "text NULL COMMENT '房间相册'",
            'device' => "text NULL COMMENT '服务设施'",
            'room_pid' => "int(11) NULL DEFAULT '0' COMMENT '主房ID'",
            'is_suite' => "int(11) NULL DEFAULT '0' COMMENT '是否是套房'",
            'area' => "decimal(11,2) NULL COMMENT '面积'",
            'room_num' => "int(11) NULL COMMENT '几室'",
            'toilet_num' => "int(11) NULL COMMENT '几卫'",
            'bed_children' => "int(11) NULL COMMENT '儿童床位数'",
            'bed_adult' => "int(11) NULL COMMENT '成人床位数'",
            'bed' => "int(11) NULL COMMENT '床位数'",
            'cleaning_fee' => "decimal(11,2) NULL DEFAULT '0.00' COMMENT '清洁费'",
            'server_fee' => "decimal(11,2) NULL COMMENT '服务费'",
            'persons' => "int(11) NULL DEFAULT '0' COMMENT '最多容纳人数'",
            'bedadd' => "varchar(30) NULL DEFAULT '' COMMENT '是否可加床'",
            'status' => "int(11) NULL DEFAULT '0' COMMENT '房间状态'",
            'isshow' => "int(11) NULL DEFAULT '0' COMMENT '是否显示'",
            'sales' => "text NULL COMMENT '销售数量'",
            'displayorder' => "int(11) NULL DEFAULT '0' COMMENT '排序'",
            'area_show' => "int(11) NULL DEFAULT '0' COMMENT '是否显示具体位置'",
            'floor_show' => "int(11) NULL DEFAULT '0' COMMENT '是否显示楼层'",
            'smoke_show' => "int(11) NULL DEFAULT '0' COMMENT '是否显示抽烟'",
            'bed_show' => "int(11) NULL DEFAULT '0' COMMENT '是否添加床位'",
            'persons_show' => "int(11) NULL COMMENT '是否显示添加人数'",
            'bedadd_show' => "int(11) NULL DEFAULT '0' COMMENT '是否显示添加床位'",
            'score' => "int(11) NULL DEFAULT '0' COMMENT '订房积分'",
            'breakfast' => "tinyint(3) NULL DEFAULT '0' COMMENT '0无早 1单早 2双早'",
            'language' => "tinyint(4) NOT NULL DEFAULT '0' COMMENT '语言类型标志/默认中文0'",
            'free_cancel' => "tinyint(4) NULL DEFAULT '0' COMMENT '是否免费取下1是0否'",
            'checkin_start' => "varchar(30) NULL COMMENT '入住开始时间'",
            'checkin_end' => "varchar(30) NULL COMMENT '入住结束时间'",
            'cancel_start' => "varchar(30) NULL COMMENT '取消开始时间'",
            'cancel_end' => "varchar(30) NULL COMMENT '退房结束时间'",
            'out_time' => "datetime NULL COMMENT '最后离店时间'",
            'time_length' => "int(11) NULL COMMENT '租约类型：小时，月，天，年'",
            'time_type' => "int(11) NULL DEFAULT '0' COMMENT '租期:1长租2短租'",
            'lease_type' => "int(11) NULL DEFAULT '0' COMMENT '1整租 2合租'",
            'desc' => "varchar(255) NULL COMMENT '房间介绍'",
            'content' => "text NULL COMMENT '房间详情'",
            'remark' => "text NULL COMMENT '备注'",
            'room_type' => "int(11) NULL COMMENT '全局房型'",
            'room_type_id' => "int(11) NULL DEFAULT '0' COMMENT '房型id'",
            'landlord_id' => "int(11) NULL COMMENT '房东'",
            'comment_num' => "int(11) NULL DEFAULT '0' COMMENT '评价数量'",
            'comment_start' => "decimal(11,2) NULL DEFAULT '5.00' COMMENT '评价星级'",
            'PRIMARY KEY (`id`)'
        ], "ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC");
        
        /* 索引设置 */
        $this->createIndex('indx_hotelid','{{%diandi_place_room}}','hotel_id',0);
        
        
        /* 表数据 */
        $this->insert('{{%diandi_place_room}}',['id'=>'1','bloc_id'=>'93','store_id'=>'2','hotel_id'=>'106','type_id'=>'23','title'=>'昆仑金','tier_id'=>NULL,'unit_id'=>NULL,'thumb'=>'202401/31/e5e7f96b-4bb7-3e81-86b2-6277bda3dee5.jpg','oprice'=>'2.00','cprice'=>'2.00','mprice'=>'2.00','thumbs'=>'a:1:{i:0;s:50:"202401/31/5b9bb817-c5b4-3244-9e7b-f2cfba46bd24.jpg";}','device'=>'','room_pid'=>'0','is_suite'=>'0','area'=>'2.00','room_num'=>'11','toilet_num'=>'1','bed_children'=>'2','bed_adult'=>'2','bed'=>'4','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'2','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'11','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'14:11:42','checkin_end'=>'15:11:42','cancel_start'=>'14:11:43','cancel_end'=>'15:11:43','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'房间简介','content'=>'<p>房间详情<br/></p>','remark'=>'','room_type'=>'0','room_type_id'=>'1','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'2','bloc_id'=>'93','store_id'=>'2','hotel_id'=>'106','type_id'=>'23','title'=>'昆仑木','tier_id'=>NULL,'unit_id'=>NULL,'thumb'=>'202401/31/94fd3d5e-15f8-32c5-a919-73231f600178.jpg','oprice'=>'2.00','cprice'=>'2.00','mprice'=>'2.00','thumbs'=>'a:1:{i:0;s:50:"202401/31/a77df9ac-e9e1-3826-83b1-aace28fc4f87.jpg";}','device'=>'','room_pid'=>'0','is_suite'=>'0','area'=>'2.00','room_num'=>'11','toilet_num'=>'1','bed_children'=>'2','bed_adult'=>'2','bed'=>'4','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'2','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'11','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'14:11:42','checkin_end'=>'15:11:42','cancel_start'=>'14:11:43','cancel_end'=>'15:11:43','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'房间简介','content'=>'<p>房间详情</p>','remark'=>'','room_type'=>'0','room_type_id'=>'1','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'3','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'108','type_id'=>'15','title'=>'101','tier_id'=>'220','unit_id'=>NULL,'thumb'=>'202401/15/a6a850d9-1a9a-3daf-8454-15c41e71511d.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202401/15/f6de5296-f68f-3d03-a2f2-31ae70468f30.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'0','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>'15','room_type_id'=>'2','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'4','bloc_id'=>'103','store_id'=>'294','hotel_id'=>'0','type_id'=>'0','title'=>'会议室','tier_id'=>NULL,'unit_id'=>NULL,'thumb'=>'202402/01/0cb99dc8-5026-316a-8fae-a225deb78ace.jpg','oprice'=>'160.00','cprice'=>'130.00','mprice'=>'120.00','thumbs'=>'a:3:{i:0;s:50:"202402/01/4715858e-bf7f-3207-8a50-410417f9723b.jpg";i:1;s:50:"202402/01/0a7f7388-cc49-376b-80b7-ec2bbf68f071.jpg";i:2;s:50:"202402/01/329f837a-7355-30ea-a542-9b5b933a1ed0.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>'80.00','room_num'=>'1','toilet_num'=>'1','bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'12','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'1','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'16:28:50','checkin_end'=>'17:28:50','cancel_start'=>'16:28:52','cancel_end'=>'17:28:52','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'1','content'=>'<p>1</p>','remark'=>NULL,'room_type'=>'0','room_type_id'=>'1','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'5','bloc_id'=>'98','store_id'=>'296','hotel_id'=>'111','type_id'=>'3','title'=>'智慧公寓','tier_id'=>NULL,'unit_id'=>NULL,'thumb'=>'202402/01/0fec1e6e-9775-3860-9a50-96ea890c18af.jpg','oprice'=>'399.00','cprice'=>'280.00','mprice'=>'299.00','thumbs'=>'a:2:{i:0;s:50:"202402/01/a28acf6e-6674-3339-aff3-133dcc4c1bba.jpg";i:1;s:50:"202402/01/920d3d7b-0c61-3a82-9891-71adcc9579a9.jpg";}','device'=>'','room_pid'=>'0','is_suite'=>'0','area'=>'120.00','room_num'=>'2','toilet_num'=>'3','bed_children'=>'1','bed_adult'=>'1','bed'=>'2','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'12','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'1','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'17:17:54','checkin_end'=>'18:17:54','cancel_start'=>'17:17:55','cancel_end'=>'18:17:55','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'1','content'=>'<p>2</p>','remark'=>'','room_type'=>'1','room_type_id'=>'3','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'6','bloc_id'=>'98','store_id'=>'296','hotel_id'=>'111','type_id'=>'22','title'=>'房间测试','tier_id'=>'221','unit_id'=>NULL,'thumb'=>'202402/02/fd959f8b-83f1-3db9-85f7-8dd06753c2b8.jpg','oprice'=>'1.00','cprice'=>'11.00','mprice'=>'2.00','thumbs'=>'a:1:{i:0;s:50:"202402/02/0e428241-e17f-3def-8700-0e54aa4133d4.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>'1.00','room_num'=>'1','toilet_num'=>'1','bed_children'=>'1','bed_adult'=>'11','bed'=>'12','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'5','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'11','displayorder'=>'11','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'14:58:29','checkin_end'=>'15:58:29','cancel_start'=>'14:58:31','cancel_end'=>'15:58:31','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'11','content'=>'<p>12</p>','remark'=>NULL,'room_type'=>'15','room_type_id'=>'2','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'7','bloc_id'=>'98','store_id'=>'297','hotel_id'=>'0','type_id'=>NULL,'title'=>'南京1','tier_id'=>'223','unit_id'=>NULL,'thumb'=>'202402/03/953f13ce-3ee8-3602-bbb5-6bd0ea507f82.jpg','oprice'=>'1.00','cprice'=>'1.00','mprice'=>'1.00','thumbs'=>'a:2:{i:0;s:50:"202402/03/c5397f4b-eca1-3b31-8dba-a16ac9f1fbcb.jpg";i:1;s:50:"202402/03/a5e6fe75-377a-3998-b977-76fcc0458a43.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>'1.00','room_num'=>'11','toilet_num'=>'1','bed_children'=>'1','bed_adult'=>'2','bed'=>NULL,'cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'1','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'1','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'11','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'21:16:50','checkin_end'=>'22:16:50','cancel_start'=>'21:16:51','cancel_end'=>'22:16:51','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'1','content'=>'<p>·1·1</p>','remark'=>NULL,'room_type'=>NULL,'room_type_id'=>'3','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'8','bloc_id'=>'98','store_id'=>'297','hotel_id'=>'112','type_id'=>'0','title'=>'南京1','tier_id'=>'223','unit_id'=>NULL,'thumb'=>'202402/03/953f13ce-3ee8-3602-bbb5-6bd0ea507f82.jpg','oprice'=>'1.00','cprice'=>'1.00','mprice'=>'1.00','thumbs'=>'a:2:{i:0;s:50:"202402/03/c5397f4b-eca1-3b31-8dba-a16ac9f1fbcb.jpg";i:1;s:50:"202402/03/a5e6fe75-377a-3998-b977-76fcc0458a43.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>'1.00','room_num'=>'11','toilet_num'=>'1','bed_children'=>'1','bed_adult'=>'2','bed'=>'3','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'1','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'1','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'11','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'21:16:50','checkin_end'=>'22:16:50','cancel_start'=>'21:16:51','cancel_end'=>'22:16:51','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'1','content'=>'<p>·1·1</p>','remark'=>NULL,'room_type'=>'2','room_type_id'=>'3','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'9','bloc_id'=>'98','store_id'=>'298','hotel_id'=>'113','type_id'=>'0','title'=>'新民宿单间','tier_id'=>'224','unit_id'=>NULL,'thumb'=>'202402/03/835fa514-7abf-31bf-b0f9-24ea729d3689.jpg','oprice'=>'1.00','cprice'=>'1.00','mprice'=>'1.00','thumbs'=>'a:1:{i:0;s:50:"202402/03/002c292a-beec-3e3d-8a65-1a11f555e21d.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>'1.00','room_num'=>'1','toilet_num'=>'11','bed_children'=>NULL,'bed_adult'=>'1','bed'=>'1','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'1','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'1','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'11','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'22:07:39','checkin_end'=>'23:07:39','cancel_start'=>'22:07:41','cancel_end'=>'23:07:41','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'11','content'=>'<p>122121</p>','remark'=>NULL,'room_type'=>'1','room_type_id'=>'4','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'10','bloc_id'=>'106','store_id'=>'299','hotel_id'=>'114','type_id'=>'0','title'=>'河北测试房型','tier_id'=>'225','unit_id'=>NULL,'thumb'=>'202402/10/714f76b9-ad1d-3dc1-a337-78b18cce4474.png','oprice'=>'1.00','cprice'=>'1.00','mprice'=>'1.00','thumbs'=>'a:1:{i:0;s:50:"202402/10/288d2c87-59ab-3879-9cd1-a127148db447.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>'1.00','room_num'=>'11','toilet_num'=>'1','bed_children'=>'1','bed_adult'=>'1','bed'=>'2','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'1','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'1','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'11','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'19:19:50','checkin_end'=>'20:19:50','cancel_start'=>'19:19:52','cancel_end'=>'20:19:52','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'1','content'=>'<p>3223</p>','remark'=>NULL,'room_type'=>'1','room_type_id'=>'5','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'11','bloc_id'=>'107','store_id'=>'300','hotel_id'=>'115','type_id'=>'0','title'=>'特色大床房春节特价','tier_id'=>'226','unit_id'=>NULL,'thumb'=>'202402/16/5acf20c5-ab93-378f-94a6-59ccaa4b549a.jpg','oprice'=>'2.00','cprice'=>'2.00','mprice'=>'2.00','thumbs'=>'a:1:{i:0;s:50:"202402/16/c0bb1bfc-2463-3227-803b-500a11146593.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>'2.00','room_num'=>'1','toilet_num'=>'11','bed_children'=>'2','bed_adult'=>'2','bed'=>'4','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'1','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'11','displayorder'=>'11','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'16:20:31','checkin_end'=>'17:20:31','cancel_start'=>'16:20:32','cancel_end'=>'17:20:32','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'1','content'=>'<p>房间详情</p><p><sup><img src=\"https://www.dandicloud.cn/admin/../attachment/image/20240216/1708071654492262.jpg\" title=\"1708071654492262.jpg\" alt=\"1K0A9267_1.jpg\"/></sup><br/></p>','remark'=>NULL,'room_type'=>'2','room_type_id'=>'6','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'12','bloc_id'=>'38','store_id'=>'302','hotel_id'=>'116','type_id'=>'0','title'=>'春节特价酒店演示','tier_id'=>'227','unit_id'=>NULL,'thumb'=>'202402/16/406bf729-ba4b-3fd9-8569-e5527aa45c03.jpg','oprice'=>'2.00','cprice'=>'2.00','mprice'=>'2.00','thumbs'=>'a:1:{i:0;s:50:"202402/16/350d3a5d-19f0-3d3d-b448-507b41645292.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>'2.00','room_num'=>'22','toilet_num'=>'2','bed_children'=>'1','bed_adult'=>'2','bed'=>'3','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'2','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'22','displayorder'=>'2','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'17:33:51','checkin_end'=>'18:33:51','cancel_start'=>'17:33:52','cancel_end'=>'18:33:52','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'12','content'=>'<p>2323<img src=\"https://www.dandicloud.cn/admin/../attachment/image/20240216/1708076051339968.jpg\" title=\"1708076051339968.jpg\" alt=\"01_副本2.jpg\"/></p>','remark'=>NULL,'room_type'=>'1','room_type_id'=>'7','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'13','bloc_id'=>'114','store_id'=>'303','hotel_id'=>'117','type_id'=>'0','title'=>'店滴茶室','tier_id'=>'229','unit_id'=>NULL,'thumb'=>'202402/19/3f74c866-b4bc-38ed-8f22-973b3386d750.jpg','oprice'=>'5.00','cprice'=>'55.00','mprice'=>'5.00','thumbs'=>'a:1:{i:0;s:50:"202402/19/3c9712e6-323b-30f9-a150-fe9a42730b17.jpg";}','device'=>'','room_pid'=>'0','is_suite'=>'0','area'=>'5.00','room_num'=>'1','toilet_num'=>'11','bed_children'=>'5','bed_adult'=>'5','bed'=>'10','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'1','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'1','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'11','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'09:02:31','checkin_end'=>'10:02:31','cancel_start'=>'09:02:32','cancel_end'=>'10:02:32','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'11','content'=>'<p>1</p>','remark'=>'','room_type'=>'1','room_type_id'=>'8','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'14','bloc_id'=>'98','store_id'=>'296','hotel_id'=>'113','type_id'=>'2','title'=>'101','tier_id'=>'230','unit_id'=>'2','thumb'=>'202402/21/a2b3ce6b-699d-3c45-b17a-9c21f2ad0847.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202402/21/2d2c202e-eae1-3390-a825-d66e60aa5115.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>'30','room_type_id'=>'27','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'15','bloc_id'=>'98','store_id'=>'296','hotel_id'=>'113','type_id'=>'2','title'=>'12','tier_id'=>'230','unit_id'=>'3','thumb'=>'202402/21/59331a31-7b07-3fbf-90d8-a64157dc8f77.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202402/21/eeea1d85-0bca-3c41-a302-6620950162cb.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>'30','room_type_id'=>'27','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'16','bloc_id'=>'98','store_id'=>'296','hotel_id'=>'113','type_id'=>'2','title'=>'102-2','tier_id'=>'230','unit_id'=>'2','thumb'=>'202402/21/4c5d8a92-6e0c-319f-9f05-e0bb7b5ad010.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202402/21/13198cc4-a32c-373d-b5db-2705e3d8bd01.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>'30','room_type_id'=>'27','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'17','bloc_id'=>'98','store_id'=>'296','hotel_id'=>'112','type_id'=>'1','title'=>'101','tier_id'=>'223','unit_id'=>NULL,'thumb'=>'202402/21/36cf5375-df3d-380a-b2aa-02d0d51b9380.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202402/21/52c913e7-c5ae-39d5-b57d-704a4410d57a.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>'2','room_type_id'=>'3','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'18','bloc_id'=>'144','store_id'=>'309','hotel_id'=>'122','type_id'=>'0','title'=>'aaaaaaaa','tier_id'=>'234','unit_id'=>NULL,'thumb'=>'202403/21/45224ce6-f337-36e1-80d1-011ba827fed0.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202403/21/df8f2275-64d3-3fd8-a05d-019f53231c99.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'0','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>NULL,'displayorder'=>'0','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'0','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'12:21:22','checkin_end'=>'13:21:22','cancel_start'=>'12:21:24','cancel_end'=>'13:21:24','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>NULL,'content'=>'','remark'=>NULL,'room_type'=>'3','room_type_id'=>'28','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'19','bloc_id'=>'159','store_id'=>'308','hotel_id'=>'124','type_id'=>'0','title'=>'休闲茶室','tier_id'=>'235','unit_id'=>NULL,'thumb'=>'202403/28/51ebc58d-f822-30ef-9b8f-a0ae5692083c.jpg','oprice'=>'1.00','cprice'=>'1.00','mprice'=>'1.00','thumbs'=>'a:1:{i:0;s:50:"202403/28/249f032f-fba3-322d-a246-c6644637fa62.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>'1.00','room_num'=>'1','toilet_num'=>'11','bed_children'=>'1','bed_adult'=>'1','bed'=>'2','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'5','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'1','displayorder'=>'11','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'09:08:45','checkin_end'=>'10:08:45','cancel_start'=>'09:08:46','cancel_end'=>'10:08:46','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'11212','content'=>'<p>12</p>','remark'=>NULL,'room_type'=>'1','room_type_id'=>'29','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'20','bloc_id'=>'189','store_id'=>'310','hotel_id'=>'125','type_id'=>'0','title'=>'大大大','tier_id'=>'236','unit_id'=>NULL,'thumb'=>'202403/30/d612bda3-6f7a-3488-a364-08bb7b607ec7.jpg','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202403/30/e7428a52-ca97-35c5-8974-790010cfc8ac.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'0','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>NULL,'displayorder'=>'0','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'0','breakfast'=>'1','language'=>'0','free_cancel'=>'1','checkin_start'=>'16:19:46','checkin_end'=>'17:19:46','cancel_start'=>'16:19:48','cancel_end'=>'17:19:48','out_time'=>'2024-03-21 12:07:27','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>NULL,'content'=>'','remark'=>NULL,'room_type'=>'2','room_type_id'=>'30','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        
        /* 设置外键约束 */
        $this->execute('SET foreign_key_checks = 1;');
    }

    public function down()
    {
        $this->execute('SET foreign_key_checks = 0');
        /* 删除表 */
        $this->dropTable('{{%diandi_place_room}}');
        $this->execute('SET foreign_key_checks = 1;');
    }
}

